package com.example.swaggerDemo.Dao;

import com.example.swaggerDemo.entity.userbyordeView;
import com.example.swaggerDemo.service.UserbyordeViewService;
import org.springframework.web.bind.annotation.RequestParam;

import java.sql.SQLException;
import java.util.List;

public interface userbyordeViewDao {
    List<userbyordeView> findUpUserIdByType(@RequestParam("upuserid") String upuserid,
                                            @RequestParam("typedata") String typedata,
                                            @RequestParam("statustype") String statustype,
                                            @RequestParam("pageindex") int pagindex,
                                            @RequestParam("pagesize") int pagesize,
                                            @RequestParam("username") String username
    )
            throws SQLException;

    List<userbyordeView> findUserIdByType(@RequestParam("upuserid") String upuserid,
                                          @RequestParam("typedata") String typedata,
                                          @RequestParam("pageindex") int pagindex,
                                          @RequestParam("pagesize") int pagesize
    )
            throws SQLException;

    List<userbyordeView> findAssitantidByType(@RequestParam("upuserid") String assitantid,
                                              @RequestParam("statustype") String statustype,
                                              @RequestParam("pageindex") int pagindex,
                                              @RequestParam("pagesize") int pagesize,
                                              @RequestParam("username") String username
    )
            throws SQLException;
}
